package zth;

import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
///import javax.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import jakarta.servlet.http.HttpSession;

import java.io.File;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.List;

public class Addcontent extends HttpServlet
{
    private static final String UPLOAD_DIRECTORY = "uploaduser";
    private static final String INSERT_TEMPLATE =
            "insert into photoinf(id,name,sex,tel,qq,text,pics) " +
                    "values('%s','%s','%s','%s','%s','%s','%s')";
    private static final int MEMORY_THRESHOLD   = 1024 * 1024 * 3;  // 3MB
    private static final int MAX_FILE_SIZE      = 1024 * 1024 * 40; // 40MB
    private static final int MAX_REQUEST_SIZE   = 1024 * 1024 * 50; // 50MB


    public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException {
        doPost(request,response);
    }
    public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException {
//        response.sendRedirect("./photographer/introduce/index.html");
//                    PrintWriter writer0 = response.getWriter();
//            writer0.println("hera99!");
//            writer0.flush();//ok！
        String id =request.getParameter("id");
        String name =request.getParameter("name");
        String sex =request.getParameter("gender");
        String tel =request.getParameter("tel");
        String qq =request.getParameter("qq");
        String text = request.getParameter("text");
//       // String sql = String.format(INSERT_TEMPLATE,id,name,sex,tel,qq,describe);
//
        // 检测是否为多媒体上传
//        if (!ServletFileUpload.isMultipartContent((javax.servlet.http.HttpServletRequest) request)) {
//            // 如果不是则停止
//            PrintWriter writer = response.getWriter();
//            writer.println("Error: 表单必须包含 enctype=multipart/form-data");
//            writer.flush();
//            return;
//        }
        // 配置上传参数
        DiskFileItemFactory factory = new DiskFileItemFactory();
        // 设置内存临界值 - 超过后将产生临时文件并存储于临时目录中
        factory.setSizeThreshold(MEMORY_THRESHOLD);
        // 设置临时存储目录
        factory.setRepository(new File(System.getProperty("java.io.tmpdir")));

        ServletFileUpload upload = new ServletFileUpload(factory);
        // 设置最大文件上传值
        upload.setFileSizeMax(MAX_FILE_SIZE);
        // 设置最大请求值 (包含文件和表单数据)
        upload.setSizeMax(MAX_REQUEST_SIZE);
        // 中文处理
        upload.setHeaderEncoding("UTF-8");

        // 构造临时路径来存储上传的文件
        // 这个路径相对当前应用的目录
        String uploadPath = request.getServletContext().getRealPath("./") + File.separator + UPLOAD_DIRECTORY;
        // 如果目录不存在则创建
        File uploadDir = new File(uploadPath);
        if (!uploadDir.exists()) {
            uploadDir.mkdir();
        }



        String pics = "";
        try {
            // 解析请求的内容提取文件数据
            List<FileItem> formItems = upload.parseRequest((javax.servlet.http.HttpServletRequest) request);
            if (formItems != null && formItems.size() > 0) {
                // 迭代表单数据
                for (FileItem item : formItems) {
                    // 处理不在表单中的字段
                    if (!item.isFormField()) {
                        String fileName = new File(item.getName()).getName();
                        String filePath = uploadPath + File.separator + fileName;
                        File storeFile = new File(filePath);
                        // 在控制台输出文件的上传路径
                        System.out.println(filePath);
                        // 保存文件到硬盘
                        item.write(storeFile);
                        pics += fileName + ",";
                    } else {
                        if (item.getFieldName().equals("id")) {
                            id = item.getString();
                        }
                        if (item.getFieldName().equals("name")) {
                            name = item.getString();
                        }
                        if (item.getFieldName().equals("sex")) {
                            sex = item.getString();
                        }
                        if (item.getFieldName().equals("tel")) {
                            tel = item.getString();
                        }
                        if (item.getFieldName().equals("qq")) {
                            qq = item.getString();
                        }
                        if (item.getFieldName().equals("text")) {
                            text = item.getString();
                        }
                    }
                }
            }

        }catch (Exception e) {
            e.printStackTrace();
        }

//        PrintWriter writer = response.getWriter();
//        writer.println("hera2!");
//        writer.flush();//ok！
        String sql = String.format(INSERT_TEMPLATE,id,name,sex,tel,qq,text,pics);
        System.out.println(sql);

        try {
            DBUtils.insert(sql);
            response.sendRedirect("./photographer/introduce/index.html");
        } catch (SQLException e) {
            PrintWriter writer2 = response.getWriter();
            writer2.println("hera4343!");
            writer2.flush();//ok！
            e.printStackTrace();
        }



//        PrintWriter writer = response.getWriter();
//        writer.println("hera!");
//        writer.flush();//ok！
//        try {
////            PrintWriter writer = response.getWriter();
////            writer.println("hera!");
////            writer.flush();//ok！
//       DBUtils.insert(sql);//到这个地方为止，是向里面添加了需要的信息也就是在html页面会显示出来
////            PrintWriter writer = response.getWriter();
////            writer.println("hera!");
//        //    writer.flush();//ok！
//            //response.sendRedirect("./login.html");
//            response.sendRedirect("./photographer/introduce/index.html");
//        } catch (SQLException e) {
//            e.printStackTrace();
//        }
    }
}
